package com.ams.mapper;

import com.ams.entity.Member;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * @author liuxiaoding
 * @data 2019/7/5
 */
@Mapper
public interface MemberMapper {
    @Select("select id,level,openid,user_bn userBn,last_user_ids lastUserIds,last_user_id lastUserId  from ims_ewei_shop_member where id=#{mid}")
    Member getMemberById(@Param("mid") Integer mid);

    @Select("select id,level,openid,user_bn userBn,last_user_ids lastUserIds,last_user_id lastUserId  from ims_ewei_shop_member where openid=#{openid}")
    Member getMemberByOpenId(@Param("openid") String openid);
}
